﻿<%@ Page Language="C#" MasterPageFile="~/Admin/AdminMasterPage.master" AutoEventWireup="true"
    CodeFile="ViewProviderWorkShop.aspx.cs" Inherits="Admin_ViewProviderWorkShop"
    Title="View Providers Workshop" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <div class="contents">
        <table width="100%" cellpadding="3" cellspacing="0" border="0">
            <tr>
                <td>
                    <h1>View Providers Workshop</h1>
                </td>
            </tr>
            <tr>
                <td valign="top">
                    Select Provider Company Name : 
                    <asp:DropDownList ID="ddlProviderCompanyName" runat="server" AutoPostBack="true">
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td valign="top">
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" Cellspacing="3" CellPadding="3" Width="100%" DataKeyNames="WorkShopId,ProviderCompanyId"
                        DataSourceID="sqlDsProviderWorkShop" CssClass="admin_gridstyle" PagerStyle-CssClass="pgr" GridLines="None" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
                        <Columns>
                            <asp:BoundField DataField="WorkShopId" HeaderText="WorkShopId" InsertVisible="False"
                                ReadOnly="True" SortExpression="WorkShopId" />
                            <asp:BoundField DataField="ProviderCompanyId" HeaderText="ProviderCompanyId" ReadOnly="True"
                                SortExpression="ProviderCompanyId" Visible="False" />
                            <asp:BoundField DataField="WSName" HeaderText="WSName" SortExpression="WSName" />
                            <asp:BoundField DataField="BlockNo" HeaderText="BlockNo" SortExpression="BlockNo"
                                Visible="False" />
                            <asp:BoundField DataField="AreaName" HeaderText="AreaName" SortExpression="AreaName"
                                Visible="False" />
                            <asp:BoundField DataField="BuildingName" HeaderText="BuildingName" SortExpression="BuildingName"
                                Visible="False" />
                            <asp:BoundField DataField="LevelNo" HeaderText="LevelNo" SortExpression="LevelNo"
                                Visible="False" />
                            <asp:BoundField DataField="RoomNo" HeaderText="RoomNo" SortExpression="RoomNo" Visible="False" />
                            <asp:BoundField DataField="StreetName" HeaderText="StreetName" SortExpression="StreetName"
                                Visible="False" />
                            <asp:BoundField DataField="PostCode" HeaderText="PostCode" SortExpression="PostCode" />
                            <asp:BoundField DataField="ZoneName" HeaderText="ZoneName" SortExpression="ZoneName" />
                            <asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country"
                                Visible="False" />
                            <asp:CheckBoxField DataField="Status" HeaderText="Status" SortExpression="Status" />
                            <asp:BoundField DataField="RefCEUserId" HeaderText="RefCEUserId" SortExpression="RefCEUserId"
                                Visible="False" />
                            <asp:BoundField DataField="CreatedDate" HeaderText="CreatedDate" SortExpression="CreatedDate"
                                Visible="False" />
                            <asp:BoundField DataField="ModifiedDate" HeaderText="ModifiedDate" ReadOnly="True"
                                SortExpression="ModifiedDate" />
                            <asp:BoundField DataField="Info1" HeaderText="Info1" SortExpression="Info1" Visible="False" />
                            <asp:BoundField DataField="Info2" HeaderText="Info2" SortExpression="Info2" Visible="False" />
                            <asp:BoundField DataField="Info3" HeaderText="Info3" SortExpression="Info3" Visible="False" />
                            <asp:BoundField DataField="Info4" HeaderText="Info4" SortExpression="Info4" Visible="False" />
                            <asp:BoundField DataField="Info5" HeaderText="Info5" SortExpression="Info5" Visible="False" />
                            <asp:BoundField DataField="Info6" HeaderText="Info6" SortExpression="Info6" Visible="False" />
                            <asp:BoundField DataField="Info7" HeaderText="Info7" SortExpression="Info7" Visible="False" />
                            <asp:BoundField DataField="Info8" HeaderText="Info8" SortExpression="Info8" Visible="False" />
                            <asp:BoundField DataField="Info9" HeaderText="Info9" SortExpression="Info9" Visible="False" />
                            <asp:BoundField DataField="Info10" HeaderText="Info10" SortExpression="Info10" Visible="False" />
                            <asp:CommandField ShowSelectButton="True" SelectText="Edit" />
                        </Columns>
                        <FooterStyle />
                        <PagerStyle />
                        <SelectedRowStyle />
                        <HeaderStyle CssClass="admin_gridheader" />
                        <EditRowStyle />
                        <AlternatingRowStyle CssClass="admin_gridodd" />
                        <RowStyle CssClass="admin_grideven" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="sqlDsProviderWorkShop" runat="server" ConnectionString="<%$ ConnectionStrings:TH.CX_DBConnectionString %>"
                        SelectCommand="sprocProviderWorkShopSelectItemList" SelectCommandType="StoredProcedure">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="ddlProviderCompanyName" Name="ProviderCompanyId"
                                PropertyName="SelectedValue" Type="Int64" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td valign="top">
                    <%--<asp:SqlDataSource ID="sqlDsWorkShopDetail" runat="server" ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>"
                    SelectCommand="sprocProviderWorkShopSelectSingleItem" 
                    SelectCommandType="StoredProcedure" 
                    UpdateCommand="sprocProviderWorkShopInsertUpdateSingleItem" 
                    UpdateCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="FormView1" Name="WorkShopId" PropertyName="SelectedValue"
                            Type="Int64" />
                    </SelectParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="WorkShopId" Type="Int64" />
                        <asp:Parameter Name="ProviderCompanyId" Type="Int64" />
                        <asp:Parameter Name="WSName" Type="String" />
                        <asp:Parameter Name="BlockNo" Type="String" />
                        <asp:Parameter Name="AreaName" Type="String" />
                        <asp:Parameter Name="BuildingName" Type="String" />
                        <asp:Parameter Name="LevelNo" Type="String" />
                        <asp:Parameter Name="RoomNo" Type="String" />
                        <asp:Parameter Name="StreetName" Type="String" />
                        <asp:Parameter Name="PostCode" Type="String" />
                        <asp:Parameter Name="ZoneName" Type="String" />
                        <asp:Parameter Name="Country" Type="String" />
                        <asp:Parameter Name="RefCEUserId" Type="Int64" />
                        <asp:Parameter Name="Status" Type="Boolean" />
                        <asp:Parameter Name="Info1" Type="String" />
                        <asp:Parameter Name="Info2" Type="String" />
                        <asp:Parameter Name="Info3" Type="String" />
                        <asp:Parameter Name="Info4" Type="String" />
                        <asp:Parameter Name="Info5" Type="String" />
                        <asp:Parameter Name="Info6" Type="String" />
                        <asp:Parameter Name="Info7" Type="String" />
                        <asp:Parameter Name="Info8" Type="String" />
                        <asp:Parameter Name="Info9" Type="String" />
                        <asp:Parameter Name="Info10" Type="String" />
                    </UpdateParameters>
                </asp:SqlDataSource>--%>
                </td>
            </tr>
            <tr>
                <td valign="top">
                    <%--<asp:FormView ID="FormView1" runat="server" CellPadding="4" DataKeyNames="WorkShopId,ProviderCompanyId"
                    DataSourceID="sqlDsWorkShopDetail" DefaultMode="Edit" ForeColor="#333333" 
                    ondatabound="FormView1_DataBound">
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                    <EditItemTemplate>
                        <table style="width: 100%">
                            <tr>
                                <td>
                                    WSName:
                                </td>
                                <td>
                                    <asp:TextBox ID="WSNameTextBox" runat="server" Text='<%# Bind("WSName") %>' Width="250px" />
                                    <div>
                                        <asp:RequiredFieldValidator ID="rfvWorkShopName" runat="server" ControlToValidate="WSNameTextBox"
                                            ErrorMessage="Require Work Shop Name"></asp:RequiredFieldValidator>
                                    </div>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    BlockNo:
                                </td>
                                <td>
                                    <asp:TextBox ID="BlockNoTextBox" runat="server" Text='<%# Bind("BlockNo") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    AreaName:
                                </td>
                                <td>
                                    <asp:TextBox ID="AreaNameTextBox" runat="server" Text='<%# Bind("AreaName") %>' Width="250px" />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    BuildingName:
                                </td>
                                <td>
                                    <asp:TextBox ID="BuildingNameTextBox" runat="server" Text='<%# Bind("BuildingName") %>'
                                        Width="200px" />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    LevelNo:
                                </td>
                                <td>
                                    <asp:TextBox ID="LevelNoTextBox" runat="server" Text='<%# Bind("LevelNo") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    RoomNo:
                                </td>
                                <td>
                                    <asp:TextBox ID="RoomNoTextBox" runat="server" Text='<%# Bind("RoomNo") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    StreetName:
                                </td>
                                <td>
                                    <asp:TextBox ID="StreetNameTextBox" runat="server" Text='<%# Bind("StreetName") %>'
                                        Width="200px" />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    PostCode:
                                </td>
                                <td>
                                    <asp:TextBox ID="PostCodeTextBox" runat="server" Text='<%# Bind("PostCode") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    ZoneName:
                                </td>
                                <td>
                                    <asp:DropDownList ID="ddlZone"  runat="server" AutoPostBack="false">
                                        <asp:ListItem Selected="True" Value="-1">Select</asp:ListItem>
                                        <asp:ListItem>North</asp:ListItem>
                                        <asp:ListItem>East</asp:ListItem>
                                        <asp:ListItem>South</asp:ListItem>
                                        <asp:ListItem>West</asp:ListItem>
                                        <asp:ListItem>Center</asp:ListItem>
                                    </asp:DropDownList>
                                    <asp:RequiredFieldValidator ID="rfvWorkShopName1" runat="server" ErrorMessage="Choose Zone"
                                        ControlToValidate="ddlZone" ValidationGroup="workshop" InitialValue="-1"></asp:RequiredFieldValidator>
                                    <asp:TextBox ID="ZoneNameTextBox" runat="server" Text='<%# Bind("ZoneName") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Country:
                                </td>
                                <td>
                                    <asp:TextBox ID="CountryTextBox" runat="server" />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Status:
                                </td>
                                <td>
                                    <asp:CheckBox ID="StatusCheckBox" runat="server" Checked='<%# Bind("Status") %>' />
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    &nbsp;
                                </td>
                                <td>
                                    <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                        Text="Update" />
                                    &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False"
                                        CommandName="Cancel" Text="Cancel" />
                                </td>
                            </tr>
                        </table>
                        <asp:Label ID="WorkShopIdLabel1" runat="server" Text='<%# Eval("WorkShopId") %>' />
                        <br />
                        &nbsp;<asp:Label ID="ProviderCompanyIdLabel1" runat="server" Text='<%# Eval("ProviderCompanyId") %>'
                            Visible="False" />
                    </EditItemTemplate>
                    <InsertItemTemplate>
                        ProviderCompanyId:
                        <asp:TextBox ID="ProviderCompanyIdTextBox" runat="server" Text='<%# Bind("ProviderCompanyId") %>' />
                        <br />
                        WSName:
                        <asp:TextBox ID="WSNameTextBox" runat="server" Text='<%# Bind("WSName") %>' />
                        <br />
                        BlockNo:
                        <asp:TextBox ID="BlockNoTextBox" runat="server" Text='<%# Bind("BlockNo") %>' />
                        <br />
                        AreaName:
                        <asp:TextBox ID="AreaNameTextBox" runat="server" Text='<%# Bind("AreaName") %>' />
                        <br />
                        BuildingName:
                        <asp:TextBox ID="BuildingNameTextBox" runat="server" Text='<%# Bind("BuildingName") %>' />
                        <br />
                        LevelNo:
                        <asp:TextBox ID="LevelNoTextBox" runat="server" Text='<%# Bind("LevelNo") %>' />
                        <br />
                        RoomNo:
                        <asp:TextBox ID="RoomNoTextBox" runat="server" Text='<%# Bind("RoomNo") %>' />
                        <br />
                        StreetName:
                        <asp:TextBox ID="StreetNameTextBox" runat="server" Text='<%# Bind("StreetName") %>' />
                        <br />
                        PostCode:
                        <asp:TextBox ID="PostCodeTextBox" runat="server" Text='<%# Bind("PostCode") %>' />
                        <br />
                        ZoneName:
                        <asp:TextBox ID="ZoneNameTextBox" runat="server" Text='<%# Bind("ZoneName") %>' />
                        <br />
                        Country:
                        <asp:TextBox ID="CountryTextBox" runat="server" Text='<%# Bind("Country") %>' />
                        <br />
                        Status:
                        <asp:CheckBox ID="StatusCheckBox" runat="server" Checked='<%# Bind("Status") %>' />
                        <br />
                        RefCEUserId:
                        <asp:TextBox ID="RefCEUserIdTextBox" runat="server" Text='<%# Bind("RefCEUserId") %>' />
                        <br />
                        CreatedDate:
                        <asp:TextBox ID="CreatedDateTextBox" runat="server" Text='<%# Bind("CreatedDate") %>' />
                        <br />
                        ModifiedDate:
                        <asp:TextBox ID="ModifiedDateTextBox" runat="server" Text='<%# Bind("ModifiedDate") %>' />
                        <br />
                        Info1:
                        <asp:TextBox ID="Info1TextBox" runat="server" Text='<%# Bind("Info1") %>' />
                        <br />
                        Info2:
                        <asp:TextBox ID="Info2TextBox" runat="server" Text='<%# Bind("Info2") %>' />
                        <br />
                        Info3:
                        <asp:TextBox ID="Info3TextBox" runat="server" Text='<%# Bind("Info3") %>' />
                        <br />
                        Info4:
                        <asp:TextBox ID="Info4TextBox" runat="server" Text='<%# Bind("Info4") %>' />
                        <br />
                        Info5:
                        <asp:TextBox ID="Info5TextBox" runat="server" Text='<%# Bind("Info5") %>' />
                        <br />
                        Info6:
                        <asp:TextBox ID="Info6TextBox" runat="server" Text='<%# Bind("Info6") %>' />
                        <br />
                        Info7:
                        <asp:TextBox ID="Info7TextBox" runat="server" Text='<%# Bind("Info7") %>' />
                        <br />
                        Info8:
                        <asp:TextBox ID="Info8TextBox" runat="server" Text='<%# Bind("Info8") %>' />
                        <br />
                        Info9:
                        <asp:TextBox ID="Info9TextBox" runat="server" Text='<%# Bind("Info9") %>' />
                        <br />
                        Info10:
                        <asp:TextBox ID="Info10TextBox" runat="server" Text='<%# Bind("Info10") %>' />
                        <br />
                        <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                            Text="Insert" />
                        &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False"
                            CommandName="Cancel" Text="Cancel" />
                    </InsertItemTemplate>
                    <ItemTemplate>
                        WorkShopId:
                        <asp:Label ID="WorkShopIdLabel" runat="server" Text='<%# Eval("WorkShopId") %>' />
                        <br />
                        ProviderCompanyId:
                        <asp:Label ID="ProviderCompanyIdLabel" runat="server" Text='<%# Eval("ProviderCompanyId") %>' />
                        <br />
                        WSName:
                        <asp:Label ID="WSNameLabel" runat="server" Text='<%# Bind("WSName") %>' />
                        <br />
                        BlockNo:
                        <asp:Label ID="BlockNoLabel" runat="server" Text='<%# Bind("BlockNo") %>' />
                        <br />
                        AreaName:
                        <asp:Label ID="AreaNameLabel" runat="server" Text='<%# Bind("AreaName") %>' />
                        <br />
                        BuildingName:
                        <asp:Label ID="BuildingNameLabel" runat="server" Text='<%# Bind("BuildingName") %>' />
                        <br />
                        LevelNo:
                        <asp:Label ID="LevelNoLabel" runat="server" Text='<%# Bind("LevelNo") %>' />
                        <br />
                        RoomNo:
                        <asp:Label ID="RoomNoLabel" runat="server" Text='<%# Bind("RoomNo") %>' />
                        <br />
                        StreetName:
                        <asp:Label ID="StreetNameLabel" runat="server" Text='<%# Bind("StreetName") %>' />
                        <br />
                        PostCode:
                        <asp:Label ID="PostCodeLabel" runat="server" Text='<%# Bind("PostCode") %>' />
                        <br />
                        ZoneName:
                        <asp:Label ID="ZoneNameLabel" runat="server" Text='<%# Bind("ZoneName") %>' />
                        <br />
                        Country:
                        <asp:Label ID="CountryLabel" runat="server" Text='<%# Bind("Country") %>' />
                        <br />
                        Status:
                        <asp:CheckBox ID="StatusCheckBox" runat="server" Checked='<%# Bind("Status") %>'
                            Enabled="false" />
                        <br />
                        RefCEUserId:
                        <asp:Label ID="RefCEUserIdLabel" runat="server" Text='<%# Bind("RefCEUserId") %>' />
                        <br />
                        CreatedDate:
                        <asp:Label ID="CreatedDateLabel" runat="server" Text='<%# Bind("CreatedDate") %>' />
                        <br />
                        ModifiedDate:
                        <asp:Label ID="ModifiedDateLabel" runat="server" Text='<%# Bind("ModifiedDate") %>' />
                        <br />
                        Info1:
                        <asp:Label ID="Info1Label" runat="server" Text='<%# Bind("Info1") %>' />
                        <br />
                        Info2:
                        <asp:Label ID="Info2Label" runat="server" Text='<%# Bind("Info2") %>' />
                        <br />
                        Info3:
                        <asp:Label ID="Info3Label" runat="server" Text='<%# Bind("Info3") %>' />
                        <br />
                        Info4:
                        <asp:Label ID="Info4Label" runat="server" Text='<%# Bind("Info4") %>' />
                        <br />
                        Info5:
                        <asp:Label ID="Info5Label" runat="server" Text='<%# Bind("Info5") %>' />
                        <br />
                        Info6:
                        <asp:Label ID="Info6Label" runat="server" Text='<%# Bind("Info6") %>' />
                        <br />
                        Info7:
                        <asp:Label ID="Info7Label" runat="server" Text='<%# Bind("Info7") %>' />
                        <br />
                        Info8:
                        <asp:Label ID="Info8Label" runat="server" Text='<%# Bind("Info8") %>' />
                        <br />
                        Info9:
                        <asp:Label ID="Info9Label" runat="server" Text='<%# Bind("Info9") %>' />
                        <br />
                        Info10:
                        <asp:Label ID="Info10Label" runat="server" Text='<%# Bind("Info10") %>' />
                        <br />
                    </ItemTemplate>
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <EditRowStyle BackColor="#999999" />
                </asp:FormView>--%>
                </td>
            </tr>
        </table>
    </div>
</asp:Content>
